package cn.edu.neusoft.practice.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import cn.edu.neusoft.practice.po.PatientDoctor;
import cn.edu.neusoft.practice.po.Personage;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

@Mapper
public interface PatientDoctorMapper extends BaseMapper<PatientDoctor> {
    @Select("select p.*,d.*,f.*,m.*,l.*,`user`.special from patient_doctor p,`user`,doctor_work d,department f,doctorfee m,doctor l where p.doc_id=d.doc_id AND p.depart_id2=f.department_id AND p.patient_id=#{patientId} AND p.day=d.day AND d.fee_id=m.fee_id AND p.doc_id=l.doc_id AND p.patient_id=`user`.user_name")
    List<Personage> getpersonage(Personage personage);

}
